﻿-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<根据{1}{2}{3}字串，返回产品>
-- =============================================
CREATE PROCEDURE [dbo].[proc_AB_Interface_GetProductByString]
(
	@pid VARCHAR(200)
)
AS
DECLARE @str VARCHAR(1000)
BEGIN
	set @pid=REPLACE(@pid,'{','')
	SET @pid=REPLACE(@pid,'}',',')
	SET @pid= SUBSTRING(@pid,0, LEN(@pid))
	--SELECT @pid
	SET @str='SELECT id,Title FROM Product WHERE id IN ('+@pid+')'
	EXEC(@str)
	SET NOCOUNT ON;
END